How to retrieve the serial number of an INSERT?
От | Daniel Whelan |
---|---|
Тема | How to retrieve the serial number of an INSERT? |
Дата | |
Msg-id | 216854109.1083103766@[10.0.2.10] обсуждение исходный текст |
Ответы |
Re: How to retrieve the serial number of an INSERT?
Re: How to retrieve the serial number of an INSERT? |
Список | pgsql-novice |
I have the following scenario, and I'm sure many others have wished to do something similar. I perform an insert into a table where one field is a SERIAL. I wish to perform several other inserts (on other tables) that will reference the first record based on its SERIAL field. In the application, I wish to name a file based on the SERIAL (I don't wish for postgres to name the file for me, I would just like to get at the number). The specific table is listed below. To recap, I wish to perform an insert and also receive the 'id' field value back. Is there any way for me to do this, or is there a better technique for achieving what I wish to do? Thanks! Daniel CREATE TABLE photos ( id serial NOT NULL, parent_id integer NOT NULL, photographer_id integer NOT NULL, title character varying, description character varying );
В списке pgsql-novice по дате отправления: